Tabela PhReservation

Definicja tabeli PhReservation

Name

PhReservation

Code

PhReservation

Comment

Rezerwacje


Lista kolumn tabeli PhReservation

Name

Code

ReservationID

ReservationID

StOrderItemID

StOrderItemID

AdditionalInfo

AdditionalInfo

DoctorID

DoctorID

PatientID

PatientID

ReservationNo

ReservationNo

Quantity

Quantity

ReservationDT

ReservationDT

ExpirationDT

ExpirationDT

StatusID

StatusID

DeliveryStockID

DeliveryStockID

OrderingStockID

OrderingStockID

StockItemID

StockItemID

UserID

UserID

DocumentNo

DocumentNo


Kolumna ReservationID tabeli PhReservation

Definicja kolumny ReservationID tabeli PhReservation

Name

ReservationID

Code

ReservationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StOrderItemID tabeli PhReservation

Definicja kolumny StOrderItemID tabeli PhReservation

Name

StOrderItemID

Code

StOrderItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pozycja zamówienia, której dotyczy rezerwacja


Kolumna AdditionalInfo tabeli PhReservation

Definicja kolumny AdditionalInfo tabeli PhReservation

Name

AdditionalInfo

Code

AdditionalInfo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

informacje dodatkowe


Kolumna DoctorID tabeli PhReservation

Definicja kolumny DoctorID tabeli PhReservation

Name

DoctorID

Code

DoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

id lekarza


Kolumna PatientID tabeli PhReservation

Definicja kolumny PatientID tabeli PhReservation

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

id pacjenta


Kolumna ReservationNo tabeli PhReservation

Definicja kolumny ReservationNo tabeli PhReservation

Name

ReservationNo

Code

ReservationNo

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

numer rezerwacji


Kolumna Quantity tabeli PhReservation

Definicja kolumny Quantity tabeli PhReservation

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

zarezerwowana ilosc


Kolumna ReservationDT tabeli PhReservation

Definicja kolumny ReservationDT tabeli PhReservation

Name

ReservationDT

Code

ReservationDT

Data Type

DATE

Mandatory

Yes

Comment

data rezerwacji


Kolumna ExpirationDT tabeli PhReservation

Definicja kolumny ExpirationDT tabeli PhReservation

Name

ExpirationDT

Code

ExpirationDT

Data Type

DATE

Mandatory

Yes

Comment

data wygasniecia rezerwacji


Kolumna StatusID tabeli PhReservation

Definicja kolumny StatusID tabeli PhReservation

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id statusu rezerwacji
alter table PhReservation
add constraint FK_PHRESERV_R_2349_PHRESERV foreign key (StatusID)
references PhReservationStatus (ReservationStatusID)


Kolumna DeliveryStockID tabeli PhReservation

Definicja kolumny DeliveryStockID tabeli PhReservation

Name

DeliveryStockID

Code

DeliveryStockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Magazyn na którym zarezerwowano pozycje
alter table PhReservation
add constraint FK_PHRESERV_R_2344_PHST foreign key (DeliveryStockID)
references PhSt (StID)


Kolumna OrderingStockID tabeli PhReservation

Definicja kolumny OrderingStockID tabeli PhReservation

Name

OrderingStockID

Code

OrderingStockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Magazyn który zarezerwowal pozycje
alter table PhReservation
add constraint FK_PHRESERV_R_2345_PHST foreign key (OrderingStockID)
references PhSt (StID)


Kolumna StockItemID tabeli PhReservation

Definicja kolumny StockItemID tabeli PhReservation

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Zarezerwowana pozycja asortymentu
alter table PhReservation
add constraint FK_PHRESERV_R_2343_PHSTITEM foreign key (StockItemID)
references PhStItem (StItemID)


Kolumna UserID tabeli PhReservation

Definicja kolumny UserID tabeli PhReservation

Name

UserID

Code

UserID

Data Type

NUMBER(10)

Mandatory

No

Comment

id uzytkownika


Kolumna DocumentNo tabeli PhReservation

Definicja kolumny DocumentNo tabeli PhReservation

Name

DocumentNo

Code

DocumentNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer dokumentu wydania zawierajacego rezerwacje leków


Lista kluczy tabeli PhReservation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhReservation

Definicja klucza Identifier_1 tabeli PhReservation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment